CREATE TABLE [dbo].[AsiNrdsMember]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_ID] DEFAULT (''),
[ArbitrationEthicsPending] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_ArbitrationEthicsPending] DEFAULT ((0)),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_AssociationId] DEFAULT (''),
[BirthDate] [datetime] NULL,
[CellPhoneAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_CellPhoneAreaCode] DEFAULT (''),
[CellPhoneNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_CellPhoneNumber] DEFAULT (''),
[DesignatedRealtor] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_DesignatedRealtor] DEFAULT ((0)),
[DuesWaivedLocalFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_DuesWaivedLocalFlag] DEFAULT ((0)),
[DuesWaivedNationalFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_DuesWaivedNationalFlag] DEFAULT ((0)),
[DuesWaivedStateFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_DuesWaivedStateFlag] DEFAULT ((0)),
[Email] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Email] DEFAULT (''),
[FirstName] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_FirstName] DEFAULT (''),
[Gender] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Gender] DEFAULT (''),
[Generation] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Generation] DEFAULT (''),
[HomeAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressStreet1] DEFAULT (''),
[HomeAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressStreet2] DEFAULT (''),
[HomeAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressCity] DEFAULT (''),
[HomeAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressState] DEFAULT (''),
[HomeAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressZip] DEFAULT (''),
[HomeAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomeAddressZip6] DEFAULT (''),
[HomePhoneArea] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomePhoneArea] DEFAULT (''),
[HomePhoneNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_HomePhoneNumber] DEFAULT (''),
[JoinedDate] [datetime] NULL,
[JunkMailFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_JunkMailFlag] DEFAULT ((0)),
[LastName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_LastName] DEFAULT (''),
[LocalJoinDate] [datetime] NULL,
[MailAddressStreet1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressStreet1] DEFAULT (''),
[MailAddressStreet2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressStreet2] DEFAULT (''),
[MailAddressCity] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressCity] DEFAULT (''),
[MailAddressState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressState] DEFAULT (''),
[MailAddressZip] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressZip] DEFAULT (''),
[MailAddressZip6] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MailAddressZip6] DEFAULT (''),
[MemberId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MemberId] DEFAULT (''),
[MemberType] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MemberType] DEFAULT (''),
[MiddleName] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MiddleName] DEFAULT (''),
[MlsAssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MlsAssociationId] DEFAULT (''),
[MlsId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_MlsId] DEFAULT (''),
[NationalDuesPaidDate] [datetime] NULL,
[Nickname] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Nickname] DEFAULT (''),
[NrdsInsertDate] [datetime] NULL,
[OccupationName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_OccupationName] DEFAULT (''),
[OfficeId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_OfficeId] DEFAULT (''),
[OfficeVoiceExtension] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_OfficeVoiceExtension] DEFAULT (''),
[OnlineStatus] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_OnlineStatus] DEFAULT (''),
[OnlineStatusDate] [datetime] NULL,
[OrientationDate] [datetime] NULL,
[OnRosterFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_OnRosterFlag] DEFAULT ((0)),
[PagerAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PagerAreaCode] DEFAULT (''),
[PagerNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PagerNumber] DEFAULT (''),
[PersonalFaxAreaCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PersonalFaxAreaCode] DEFAULT (''),
[PersonalFaxNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PersonalFaxNumber] DEFAULT (''),
[PointOfEntry] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PointOfEntry] DEFAULT (''),
[PreferredFax] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PreferredFax] DEFAULT (''),
[PreferredMail] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PreferredMail] DEFAULT (''),
[PreferredPhone] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PreferredPhone] DEFAULT (''),
[PreferredPublication] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PreferredPublication] DEFAULT (''),
[PreviousNonmemberFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_PreviousNonmemberFlag] DEFAULT ((0)),
[PrimaryFieldOfBusiness] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PrimaryFieldOfBusiness] DEFAULT (''),
[PrimaryIndicator] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PrimaryIndicator] DEFAULT (''),
[PrimaryStateAssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_PrimaryStateAssociationId] DEFAULT (''),
[ReinstatementCode] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_ReinstatementCode] DEFAULT (''),
[ReinstatementDate] [datetime] NULL,
[RELicense] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_RELicense] DEFAULT (''),
[Salutation] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Salutation] DEFAULT (''),
[SecondaryFieldOfBusiness1] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_SecondaryFieldOfBusiness1] DEFAULT (''),
[SecondaryFieldOfBusiness2] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_SecondaryFieldOfBusiness2] DEFAULT (''),
[SecondaryFieldOfBusiness3] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_SecondaryFieldOfBusiness3] DEFAULT (''),
[Ssn] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Permission] DEFAULT (''),
[StateDuesPaidDate] [datetime] NULL,
[Status] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Status] DEFAULT (''),
[StatusDate] [datetime] NULL,
[StopEmailFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_StopEmailFlag] DEFAULT ((0)),
[StopFaxFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_StopFaxFlag] DEFAULT ((0)),
[StopMailFlag] [bit] NOT NULL CONSTRAINT [DF_AsiNrdsMember_StopMailFlag] DEFAULT ((0)),
[Subclass] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Subclass] DEFAULT (''),
[Title] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_Title] DEFAULT (''),
[WebPage] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_WebPage] DEFAULT (''),
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMember_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsMember] ADD CONSTRAINT [PK_AsiNrdsMember] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO